﻿  
namespace EntryExit
{
    public class DBConstants
    {
        #region HRMS
        //public static string SP_AMS_GET_EMPLOYEE_DETAILS = "AMS_GetEmployeeDetails";
        //public static string SP_AMS_GET_SUB_ORDINATES = "AMS_GetSubOrdinates"; 
        public static string SP_AMS_GET_SHIFT_DETAILS = "AMS_GetShiftDetails";
        public static string SP_AMS_GET_STATUS_DETAILS = "AMS_GetStatusDetails";
        public static string SP_AMS_GET_LPN_FOR_WINDOWS_UNAME = "AMS_GetLPNForWindowsUser";
        //public static string CMD_AMS_GET_LEAVE_DISTRIBUTION_FOR_MONTH = "SELECT [EmployeeName], [LPN], [ShiftDate], [Status], [StatusID], [Shift] FROM [vw_SDT_EntryExit_EmployeeDhiftDetails] WHERE ([LPN] = @LPN)";
        public static string CMD_AMS_GET_LEAVE_DISTRIBUTION_FOR_MONTH = "SELECT [EmployeeName], [LPN], [ShiftDate], [Status], [StatusID], [Shift] FROM [vw_SDT_EntryExit_EmployeeDhiftDetails] WHERE ([LPN] = @LPN) and Status<>'Off Day'";

        public static string SP_AMS_GET_FULL_EMPLOYEE_DETAILS = "AMS_GetFullEmployeeDetails";
        public static string SP_AMS_GET_SUB_ORDINATES_WITH_CARDID = "AMS_GetSubOrdinatesWithCard";
        public static string SP_AMS_Rpt_Dashboard = "AMS_Rpt_Dashboard";
        public static string SP_AMS_RPT_LOWWORKHOURS = "Ams_rpt_getlowworkinghours";
        public static string SP_AMS_RPT_WHOISIN = "AMS_WhoIsIn";
        public static string SP_AMS_RPT_getDepartments = "AMS_getDepartments";
        public static string SP_AMS_RPT_getEmployees = "AMS_getEmployee";
        public static string SP_AMS_RPT_UpdateTempCardInfo = "AMS_Update_TempCardInfo";
        #endregion HRMS

        #region CARDAX EVENTS
        public static string SP_AMS_GET_LATEST_EVENT_OF_EMPLOYEE = "AMS_GetLatestEventOfEmployee";
        public static string SP_AMS_GET_EVENTS = "AMS_GetEvents";
        #endregion CARDAX EVENTS

        #region CARDAX CENTRAL
        //public static string SP_AMS_GET_CARD_HOLDER_ID = "AMS_GetCardHolderId";
        #endregion CARDAX CENTRAL
    }
    
    public enum DBName
    {
        SERVICE,
        CCFTEvent,
        CCFTCentral
    }
}